﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Top Manager/Top_Manager.master" AutoEventWireup="true" CodeFile="Salesbybranch.aspx.cs" Inherits="Top_Manager_Salesbybranch" %>

<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            width: 100%;
        }
        .style3
        {
            width: 238px;
        }
        .style4
        {
            width: 238px;
            height: 19px;
        }
        .style5
        {
            height: 19px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table class="style2">
        <tr>
            <td class="style3">
                &nbsp;</td>
            <td>
                <dx:ASPxLabel ID="ASPxLabel2" runat="server" Text="Select Branch" 
                    Font-Bold="True" Font-Size="Small" ForeColor="Blue">
                </dx:ASPxLabel>
            </td>
            <td>
                <dx:ASPxComboBox ID="ASPxComboBox1" runat="server" ClientIDMode="AutoID" 
                    ValueType="System.String" 
                    CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                    SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    AutoPostBack="True" 
                    onselectedindexchanged="ASPxComboBox1_SelectedIndexChanged">
                    <Items>
                        <dx:ListEditItem Text="Kandy" Value="1" />
                        <dx:ListEditItem Text="Pandura" Value="2" />
                    </Items>
                    <LoadingPanelImage Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                    </LoadingPanelImage>
                    <ButtonStyle Width="11px">
                    </ButtonStyle>
                    <ValidationSettings ErrorText="Error has occurred">
                        <ErrorFrameStyle ImageSpacing="4px">
                            <ErrorTextPaddings PaddingLeft="4px" />
                        </ErrorFrameStyle>
                    </ValidationSettings>
                </dx:ASPxComboBox>
            </td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style4">
                </td>
            <td class="style5">
                </td>
            <td class="style5">
                </td>
            <td class="style5">
                </td>
        </tr>
    </table>

    <asp:Panel ID="Panel1" runat="server">
        <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
        ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
        CssPostfix="BlackGlass" DataSourceID="SqlDataSource3" KeyFieldName="R_ID" 
        Width="100%">
            <Columns>
                <dx:GridViewCommandColumn VisibleIndex="0">
                    <ClearFilterButton Visible="True">
                    </ClearFilterButton>
                </dx:GridViewCommandColumn>
                <dx:GridViewDataTextColumn FieldName="R_ID" ReadOnly="True" VisibleIndex="0" 
                    Caption="Invoice ID">
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="D_id" VisibleIndex="1" Caption="BLAA No:">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="D_name" VisibleIndex="2" Caption="Dealer">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Total_Price" VisibleIndex="3" 
                    Caption="Total Amount">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Toatal_PV" VisibleIndex="4" 
                    Caption="Total PV">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Total_BV" VisibleIndex="5" 
                    Caption="Total BV">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="cashier_Name" VisibleIndex="6" 
                    Caption="Cashier">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataDateColumn FieldName="Rcpt_Date" VisibleIndex="7" 
                    Caption="Date">
                </dx:GridViewDataDateColumn>
            </Columns>
            <SettingsPager PageSize="25">
            </SettingsPager>
            <Settings ShowFilterRow="True" ShowFooter="True" />
            <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
                </LoadingPanelOnStatusBar>
                <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
                </LoadingPanel>
            </Images>
            <ImagesFilterControl>
                <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                </LoadingPanel>
            </ImagesFilterControl>
            <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
            CssPostfix="BlackGlass">
                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                </Header>
            </Styles>
            <StylesEditors>
                <CalendarHeader Spacing="1px">
                </CalendarHeader>
                <ProgressBar Height="25px">
                </ProgressBar>
            </StylesEditors>
        </dx:ASPxGridView>
   
<asp:SqlDataSource ID="SqlDataSource3" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
        
            SelectCommand="SELECT DISTINCT Tbl_Receipt.cashier_Name, Tbl_Receipt.D_id, Tbl_Receipt.R_ID, Tbl_Receipt.D_name, Tbl_Receipt.Total_Price, Tbl_Receipt.Toatal_PV, Tbl_Receipt.Total_BV, Tbl_Receipt.Rcpt_Date, Tbl_cashier.Status FROM Tbl_cashier INNER JOIN Tbl_Receipt ON Tbl_cashier.cashier = Tbl_Receipt.cashier_Name WHERE (Tbl_cashier.Status = '2')">
    </asp:SqlDataSource>
    <br />
     </asp:Panel>

    <asp:Panel ID="Panel2" runat="server">
        <dx:ASPxGridView ID="ASPxGridView2" runat="server" 
    ClientIDMode="AutoID" DataSourceID="SqlDataSource2" AutoGenerateColumns="False" 
            CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
            KeyFieldName="R_ID" Width="100%">
            <Columns>
                <dx:GridViewCommandColumn VisibleIndex="0">
                    <ClearFilterButton Visible="True">
                    </ClearFilterButton>
                </dx:GridViewCommandColumn>
                <dx:GridViewDataTextColumn FieldName="R_ID" ReadOnly="True" 
                    ShowInCustomizationForm="True" VisibleIndex="0" Caption="Invoice ID">
                    <EditFormSettings Visible="False" />
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="D_id" ShowInCustomizationForm="True" 
                    VisibleIndex="1" Caption="BLAA No:">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="D_name" ShowInCustomizationForm="True" 
                    VisibleIndex="2" Caption="Dealer">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Total_Price" 
                    ShowInCustomizationForm="True" VisibleIndex="3" Caption="Total Amount">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Toatal_PV" ShowInCustomizationForm="True" 
                    VisibleIndex="4" Caption="Total PV">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="Total_BV" ShowInCustomizationForm="True" 
                    VisibleIndex="5" Caption="Total BV">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataTextColumn FieldName="cashier_Name" 
                    ShowInCustomizationForm="True" VisibleIndex="6" Caption="Cashier">
                </dx:GridViewDataTextColumn>
                <dx:GridViewDataDateColumn FieldName="Rcpt_Date" ShowInCustomizationForm="True" 
                    VisibleIndex="7" Caption="Date">
                </dx:GridViewDataDateColumn>
            </Columns>
            <SettingsPager PageSize="25">
            </SettingsPager>
            <Settings ShowFilterRow="True" ShowFooter="True" />
            <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
                </LoadingPanelOnStatusBar>
                <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
                </LoadingPanel>
            </Images>
            <ImagesFilterControl>
                <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                </LoadingPanel>
            </ImagesFilterControl>
            <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                CssPostfix="BlackGlass">
                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                </Header>
            </Styles>
            <StylesEditors>
                <CalendarHeader Spacing="1px">
                </CalendarHeader>
                <ProgressBar Height="25px">
                </ProgressBar>
            </StylesEditors>
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
            
            SelectCommand="SELECT DISTINCT Tbl_Receipt.cashier_Name, Tbl_Receipt.D_id, Tbl_Receipt.R_ID, Tbl_Receipt.D_name, Tbl_Receipt.Total_Price, Tbl_Receipt.Toatal_PV, Tbl_Receipt.Total_BV, Tbl_Receipt.Rcpt_Date, Tbl_cashier.Status FROM Tbl_cashier INNER JOIN Tbl_Receipt ON Tbl_cashier.cashier = Tbl_Receipt.cashier_Name WHERE (Tbl_cashier.Status = '1')">
        </asp:SqlDataSource>

    </asp:Panel>
    

</asp:Content>

